package com.smfx.yxt.daoSqlserver;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import com.smfx.yxt.model.SchoolPropertyInput;
import com.smfx.yxt.page.Page;
import com.smfx.yxt.reqVo.SchoolPropertyExportQueryVo;
import com.smfx.yxt.view.SchoolPropertyInputExportView;

/**
 * 入库信息
 * */
public interface SchoolPropertyInputMapper {

    int insert(SchoolPropertyInput record);

    int insertSelective(SchoolPropertyInput record);

    SchoolPropertyInput selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(SchoolPropertyInput record);

	List<SchoolPropertyInput> selectInputRecordByPage(Page<SchoolPropertyInput> page);

	@Update("update T_SCHOOL_PROPERTY_INPUT set TOTAL_MONEY = TOTAL_MONEY + #{d,jdbcType=DOUBLE} where id = #{id,jdbcType=INTEGER}")
	int updateTotalPriceById(@Param("id")Integer inputId, @Param("d")double d);

	List<SchoolPropertyInputExportView> selectSchoolPropertyInputForExportToExcelByPage(Page<SchoolPropertyInputExportView> page);

	List<SchoolPropertyInputExportView> selectSchoolPropertyInputForExportToExcelByParams(SchoolPropertyExportQueryVo vo);
}